<!-- ************************************************************************************************************ -->
<!-- fileName          : EditTopguideLink.jsp																	  -->
<!-- author            : 马文军 																					  --> 
<!-- createDate        : 2015/01/06 																			  -->
<!-- summary           : admin端  “顶部导航” 编辑 链接   后台逻辑 														  		  -->
<!-- modifiedBy        : 马文军																				      -->
<!-- ************************************************************************************************************ -->

<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<title>EditTopguideLink</title>
<script type="text/javascript" src="../../js/jquery.js"></script>
<script type="text/javascript" src="../../js/validator.js"></script>
<script type="text/javascript">
$.ajaxSetup ({
   	cache: false //关闭AJAX相应的缓存
});
</script>
<style type="text/css">
body{
background-image:url(../../image/admin_bg.png);
background-repeat:repeat-x;
margin-left: 0px;
margin-top: 0px;
margin-right: 1px;
margin-bottom: 0px;
font-family:Microsoft YaHei;
}
h2{
font-family:Microsoft YaHei;
color:#fff;
margin: 5px 5px 5px 5px;
font-size:16px;
}
</style>

</head>
<body>
<%
	//设置请求的字符编码以支持中文
	request.setCharacterEncoding ("utf-8");

	//从请求页面获取表单参数
    String id = request.getParameter("id");
    System.out.println("编辑topguide链接	id="+id);
   
	//从web.xml文件获取全局参数
	String drv=config.getServletContext().getInitParameter("DBDriver");
	String url=config.getServletContext().getInitParameter("DBURL");
	String uid=config.getServletContext().getInitParameter("DBUser");
	String pwd=config.getServletContext().getInitParameter("DBPass");
	
    //构建SQL字符串和JDBC对象
    
	String strSQL = "SELECT * FROM immie0_immi.topguide tg WHERE tg.id=?";	// (id, name, content_name, content, url, father_id, date)
	Connection conn = null;
	PreparedStatement pstmt = null;	
	ResultSet rs = null;
	
	try {
		Class.forName(drv).newInstance();
		conn = DriverManager.getConnection(url,uid,pwd);
		pstmt = conn.prepareStatement(strSQL);	
		pstmt.setString(1, id);

		rs = pstmt.executeQuery();
		rs.next();
%>
<h2>编辑链接</h2>
	<div style="margin:10px auto; width:600px; ">	
		<form id="linkForm" method="post" action="SaveTopguideLink.do">
			<div style="display:none;">
			链接ID：<input type="text" style="width: 500px;"name="id" id="id" value="<%= rs.getString(1) %>"/>
			</div>
			<div style="margin:2px auto;">
			标题：<input type="text" style="width: 500px;"name="title" id="title" value="<%= rs.getString(2) %>" onblur="checkTitle();" onClick="if(this.value=='请输入...')this.value=''" />
			</div>
			<div style="margin:2px auto;">
			地址：<input type="text" style="width: 500px;"name="topguide_url" id="topguide_url" value="<%= rs.getString(5) %>" onblur="checkTopguide_url();" onClick="if(this.value=='请输入...'|this.value=='请输入正确格式的网址，如“http://www.baidu.com”')this.value=''" />
			</div>
			<div style="margin:2px auto; width:20px; ">
				<input type="button" value="保存" onclick="save_topguidelink(this.form);" />
			</div>
		</form>
	</div>
<% 

	} catch (ClassNotFoundException e) {
		e.printStackTrace();
	} catch (InstantiationException e) {
	    e.printStackTrace();
	} catch (IllegalAccessException e) {
		e.printStackTrace();
	} catch (SQLException e) {
		e.printStackTrace();
	} 
	finally {
		if (rs != null) {
			rs.close();
			rs = null;
		}
		if (pstmt != null) {
			pstmt.close();
			pstmt = null;
		}		
		if (conn != null) {
			conn.close();
			conn = null;
		}
	}
%>
</body>
</html>